Python • Twilio API • WhatsApp Business API • Django/Flask
| Project Name | Workflow Approval System for Common Man using WhatsApp |
|---|---|
| Technologies | Python, Twilio API, WhatsApp Business API, Django/Flask |
| Problem Statement | Complex digital workflow systems are inaccessible to common users. |
| AI Component | NLP for understanding user requests, routing workflows, approval suggestions. |
| Solution | WhatsApp chatbot for submitting documents, approvals, and tracking using conversational AI. |
| Impact | Makes workflow approvals accessible to the general public, improves government & citizen service engagement. |
| Table Name | Description |
|---|---|
| citizen_requests | Tracks workflow initiation messages sent by users |
| request_metadata | Stores extracted entities using NLP (type, urgency, department) |
| approval_chain | Defines required approvers and workflow steps |
| whatsapp_messages | All inbound/outbound WhatsApp messages via API |
| approval_status | Tracks progress, timestamps, and results |
| ai_recommendations | AI suggestions for routing, escalation, or required documents |
| user_profiles | Basic info: phone, role, region, language preferences |
| Request ID | User Phone | Message | Timestamp |
|---|---|---|---|
| REQ101 | +91 9822334455 | I want to apply for an income certificate | 2025-11-19 09:22 |
| REQ102 | +91 8877665544 | Please approve my water connection request | 2025-11-19 10:10 |
| Request ID | Request Type | Urgency | Department |
|---|---|---|---|
| REQ101 | Income Certificate | Normal | Revenue Dept |
| REQ102 | Water Connection Approval | High | Municipal Water Dept |
| Request Type | Step | Approver Role | SLA (hrs) |
|---|---|---|---|
| Income Certificate | 1 | Clerk | 24 |
| Income Certificate | 2 | Tahsildar | 48 |
| Water Connection | 1 | Section Engineer | 12 |
| Message ID | From | To | Message | Status |
|---|---|---|---|---|
| MSG5001 | User | Bot | Please approve my request | Received |
| MSG5002 | Bot | User | Your request ID is REQ102 | Delivered |
| Request ID | Current Step | Status | Last Updated |
|---|---|---|---|
| REQ101 | Step 1 (Clerk) | Pending | 2025-11-19 11:30 |
| REQ102 | Step 1 (Engineer) | Approved | 2025-11-19 12:15 |
| Request ID | Recommendation | Reason |
|---|---|---|
| REQ101 | Notify Clerk for faster processing | Exceeded 40% of SLA time |
| REQ102 | Escalate to Superintendent | User urgency set to High |